convert datetime 102

Convert (, 120) 100 or 0 mon dd yyyy hh: miam (or PM) 101mm/DD/yy 102 yy. mm. DD 103 dd/mm/yy 104 DD. mm. YY 105 DD-mm-yy 106 dd mon YY 107 mon DD, YY 108 hh: mm: SS 109 or 9 Mon dd yyyy hh: MI: SS: mmmam (or pm) 110mm-dd-yy 111 YY/MM/DD 112 yymmdd 1

CONVERT (Data_type,expression[,style])CONVERT (varchar (10), field name, conversion format)DescriptionThis style is typically in the time type (Datetime,smalldatetime) and the string type (Nchar,nvarchar,char,varchar)It is only used when converting

In SQL Server, I often need to perform some time-type field conversions, but I don't quite remember it. So I collected the following sqlserverconvert datetime-related materials and posted them on my site, it is convenient for you to search for it

First, review the syntax format of CONVERT (): convert ([length], [, Style]) Second, here pay attention to the meaning of style: style is the conversion of datatime and smalldatetime data to a string by the SQL Server system provided by the

A. A review of the syntax format of CONVERT (): convert ([length], [, Style]) second, here is a note of the meaning of style: style is the conversion style number that is provided by the SQL Server system when converting Datatime and smalldatetime

Use convert in SQL server2000 to get the datetime data type style (full)Processing of date data formats, two examples:CONVERT (varchar (16), time one, 20) results: 2007-02-01 08:02/* time is generally a field in the GETDATE () function or data table

Processing of date data format: Result of convert (varchar (16), time 1, 20): 2007-02-01 08: 02 Result of convert (varchar (10), time 1, 23): 2007-02-01 Statement and query result:Select convert (varchar (100), getdate (), 0): 05 16 2006

Processing of date data formats, two examples:CONVERT (varchar (16), time one, 20) results: 2007-02-01 08:02/* time is generally a field in the GETDATE () function or data table */CONVERT (varchar (10), time one, 23) Result: 2007-02-01/*varchar (10)

CONVERT (varchar (ten), date, 23)1 02/22/06 CONVERT (varchar (), date, 1) 0 Feb 2006 4:26pm CONVERT (CHAR), Current_timestamp, 0) 1 02/22/06 CONVERT (CHAR (8), Current_timestamp, 1) 2

SQL server uses convert to obtain datetime date data. The following examples include conversions of various date formats.Statement and query result:SelectCONVERT (varchar (100), GETDATE (), 0): 05 16 2006 AMSelectCONVERT (varchar (100), GETDATE (), 1